package com.isoft.dailymanprovidor.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.isoft.dailymanprovidor.entity.MeetingSign;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface MeetingSignDao extends BaseMapper<MeetingSign> {
    //新增会议招待
    @Insert("INSERT INTO TMIM_SYSTEM.meeting_Sign(leader,department,LOCATION,DATE,CONTENT,RECEPTION,\n" +
            "RECEPTIONNUMBER,ACCOMPANY,ACCOMPANYNUMBER,SUPPORT)\n" +
            "VALUES (#{leader},#{department},#{location},#{date},#{content},#{reception},#{receptionnumber},#{accompany}" +
            ",#{accompanynumber},#{support})")
    public int addmeetingsign(MeetingSign meetingSign);

    //会议招待审核
    @Update("update TMIM_SYSTEM.meeting_Sign set status=#{status} where ID=#{id}")
    public int manupdatestatus(MeetingSign meetingSign);
}
